﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Agresso.Interface.Layer.SQL
{
    public class ud_algbatchinput_remarkSQL
    {
        public static string Insert()
        {
            return @"
            INSERT INTO [ud_algbatchinput_remark]
           ([client]
           ,[batch_id]
           ,[order_id]
           ,[ext_ord_ref]
           ,[po_remark]
            ,[processed_date])
     VALUES
           (@client
           ,@batch_id
           ,@order_id
           ,@ext_ord_ref
           ,@po_remarks
            ,getdate()
            )";
        }
        public static string CountByOrderId()
        {
            return @"Select count(*) from ud_algbatchinput_remark where order_id=@order_id";
        }
    }
}
